Sending data
Short Description
The thread is reading and processing rows for a SELECT statement, and sending data to the client.
Detailed Description​
Prior to MySQL 8.0.17​
The thread is reading and processing rows for a SELECT statement, and sending data to the client. Because operations occurring during this state tend to perform large amounts of disk access (reads), it is often the longest-running state over the lifetime of a given query.
MySQL 8.0.17 and later​
This state is no longer indicated separately, but rather is included in the Executing state.
How to reduce this wait​
- Look at the SQL statements waiting on 'Sending data' and see if they can be optimised by using indexes or rewriting to make them more efficient.
Additional Links​
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.